{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ExampleTab1","ExampleTab2","Config","Documentation"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ExampleTab1","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Last Updated:","2013-03-22T09:22:35"]
["JIRA ITEM","Title","URL","Status","Resolution","Assignee","Bugmaster Number","Global Rank"]
["JRA-22429","[JRA-22429] import into excel with web query","https://jira.atlassian.com/browse/JRA-22429","Resolved","Won't Fix","Unassigned",4329,26725]
["JRA-30918","[JRA-30918] Provide ability to customize Issue Links display within an issue","https://jira.atlassian.com/browse/JRA-30918","New","Unresolved","Unassigned",163373,182397]
[null,null,"I don't want this overwritten until a JRA gets assigned"]
[null,null,null,null,"I don't want this overwritten until a JRA gets assigned"]
[]
["JRA-28289","[JRA-28289] Custom Fields do not appear after returning to Issue Navigator from Configure causing custom fields not to be exported to Excel","https://jira.atlassian.com/browse/JRA-28289","Awaiting Development","Unresolved","Unassigned",112715,140439]
[null,"I don't want this overwritten until a JRA gets assigned"]
[null,null,null,null,null,"I don't want this overwritten until a JRA gets assigned"]
["JRA-30315","[JRA-30315] As an Admin that only has access to JIRA (but not other apps), I should see the JIRA welcome dialog","https://jira.atlassian.com/browse/JRA-30315","Resolved","Fixed","Eric Dalgliesh [Atlassian] Bugmaster",156336,175906]
["JRA-30918","[JRA-30918] Provide ability to customize Issue Links display within an issue","https://jira.atlassian.com/browse/JRA-30918","New","Unresolved","Unassigned",163373,182397]
[]
[null,null,"I don't want this overwritten until a JRA gets assigned"]
[null,null,"I don't want this overwritten until a JRA gets assigned"]

{"sheet":"ExampleTab2","index":1,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,0,1,7]]}
["Last Updated:","2013-03-22T09:22:24"]
["Row Reserved for Company XYZ's Logo"]
["JIRA ITEM","Blank Column","Error Node (To Be Skipped)","Title","Blank Column","URL","Blank Column","Blank Column"]
["JRA-30315",null,null,"[JRA-30315] As an Admin that only has access to JIRA (but not other apps), I should see the JIRA welcome dialog",null,"https://jira.atlassian.com/browse/JRA-30315"]
["JRA-30918",null,null,"[JRA-30918] Provide ability to customize Issue Links display within an issue",null,"https://jira.atlassian.com/browse/JRA-30918"]
["JRA-30315",null,null,"[JRA-30315] As an Admin that only has access to JIRA (but not other apps), I should see the JIRA welcome dialog",null,"https://jira.atlassian.com/browse/JRA-30315"]

{"sheet":"Config","index":2,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,1,3],[0,5,1,9]]}
["Worksheet Configuation",null,null,null,null,"Column Configuration"]
[]
["Worksheet Name","First Row of Records","Final Row of Records","JIRA URL",null,"Worksheet Name","Column Name","Column Number","Xpath for Data","Description of Data"]
["ExampleTab1",3,15,"https://jira.atlassian.com",null,"ExampleTab1","Title",2,"/rss/channel/item/title","Title of Issue"]
["ExampleTab2",4,6,"https://jira.atlassian.com",null,"ExampleTab1","URL",3,"/rss/channel/item/link","URL for Issue"]
[null,null,null,null,null,"ExampleTab1","Status",4,"/rss/channel/item/status","Status of Issue"]
[null,null,null,null,null,"ExampleTab1","Resolution",5,"/rss/channel/item/resolution","Issue's Resolution"]
[null,null,null,null,null,"ExampleTab1","Assignee",6,"/rss/channel/item/assignee","Issue's Assignee"]
[null,null,null,null,null,"ExampleTab1","Bugmaster Number",7,"/rss/channel/item/customfields/customfield[1]/customfieldvalues/customfieldvalue","Bugmaster Number"]
[null,null,null,null,null,"ExampleTab1","Global Rank",8,"/rss/channel/item/customfields/customfield[@id='customfield_11130']/customfieldvalues/customfieldvalue","Global Rank"]
[null,null,null,null,null,"ExampleTab2","Error Node (To Be Skipped)",3,"/rss/channel/NOTAREALNODE","An example placeholder showing what happens if a node doesn't exist or is not yet populated"]
[null,null,null,null,null,"ExampleTab2","URL",6,"/rss/channel/item/link","URL for Issue"]
[null,null,null,null,null,"ExampleTab2","Title",4,"/rss/channel/item/title","Title of Issue"]

{"sheet":"Documentation","index":3,"n_rows":72,"n_cols":5,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
["Documentaton for JIRA Scraper"]
["Last Updated 3/20/2016"]
["© WAM Enterprises William Morrison 2016"]
[]
["Supporting the Developer"]
[null,"The JIRA Scraper is fully modifiable by end-users. Nothing is password protected."]
[null,"If you would care to donate to the developer to compensate him for creating the framework, please visit"]
[null,null,"http://wamjirascraper.s3-website-us-west-2.amazonaws.com/"]
[null,"And make a donation via Paypal"]
[null,null,"Suggested rates: Individual use- $20 USD, Site use- $200 USD"]
[null,"Developer can be contacted at will.a.morison@gmail.com. Thanks for using the JIRA Scraper!"]
[]
["Starting a New Worksheet"]
[null,"To start a new worksheet, copy the entire tab 'ExampleTab1' or 'ExampleTab2'"]
[null,null,"Copying the entire tab will preserve the 'Update Button' and its associated programming"]
[null,"Worksheets must be uniquely named"]
[null,"Do not alter the cells A1 and B1 on any Worksheet"]
[null,null,"A1 is the cell for the 'Update Button'"]
[null,null,"B1 is the cell that contains the date and time of the last update"]
[null,"Column A must be used for the 'JIRA ITEM' numbers"]
[null,"All other cells of the worksheet are available for any use"]
[]
["Configuring a Worksheet"]
[null,"Open the 'Config' tab of the JIRA Scraper workbook"]
[null,"Column A, Column  B, Column  C, and Column D are used to configure each worksheet"]
[null,null,"Column A must contain the unique name of the desired worksheet"]
[null,null,"Column B must contain the number of the first row where JIRA Item numbers can be found on a given worksheet"]
[null,null,null,"This is configurable to allow for additional customization of worksheets"]
[null,null,null,"See Row 3 of 'ExampleTab2' for an example"]
[null,null,"Column C must contain the number of the final row where JIRA Item numbers can be found on a given worksheet"]
[null,null,null,"This is configurable to allow for additional customization of worksheets"]
[null,null,"Column D must contain the URL for your JIRA server"]
[null,null,null,"This will typically look like https://jira.YOURCOMPANYNAME.com/"]
[null,"Column F, Column  G, Column  H, Column I, and Column J are used to configure the desired information scraped from JIRA"]
[null,null,"Column F must contain the unique name of the desired worksheet"]
[null,null,"Column G should contain the name of the column of the desired worksheet to be updated with JIRA data"]
[null,null,null,"This column is for reference purposes only"]
[null,null,"Column H must contain the number of the column to be referenced on the desired worksheet"]
[null,null,null,"For example, if the desired worksheet is to have a 'Title' column that is located in Column B, then the number 2 would be input here"]
[null,null,null,"Column letters are translated in sequential order"]
[null,null,null,null,"For example, Column B would be written as 2, Column C is written as 3, Column D is written as 4, and so on"]
[null,null,"Column I must contain the XPATH for the data to be updated from JIRA"]
[null,null,null,"If XPATH leads to an inaccessable node, the cell will be left blank"]
[null,null,null,null,"See 'ExampleTab2' for an example"]
[null,null,null,"See XPATH tutorial below for more detailed instructions"]
[null,null,"Column J should contain a brief description of what data is being updated from JIRA"]
[null,null,null,"This column is for reference purposes only"]
[]
["Utilizing JIRA Scraper after configuration"]
[null,"If the 'JIRA ITEM' on the desired worksheet is blank, no cells in that row will be updated or altered"]
[null,null,"This can be used as a placeholder for data for projects or tickets that have not yet been assigned to JIRA"]
[null,"Input the JIRA Item Number in Column A"]
[null,null,"This will typically be a lettered prefix followed by numbers"]
[null,null,null,"See 'ExampleTab1' for an example"]
[null,null,"The JIRA Item will be updated with a hyperlink to the JIRA webpage when the data is updated"]
[null,"Click the 'Update Button' to update all rows that have a JIRA ITEM in Column A"]
[]
["XPATH Tutorial"]
[null,"This workbook uses XPATH to select a single item (also called a node) from a JIRA .xml document"]
[null,"Start by opening the JIRA issue/ticket page for your Item"]
[null,"Use the 'Views' dropdown and select XML"]
[null,"To select a node with a unique XPATH (for example, the Title of the issue), the XPATH simply follows the nested structure of the XML"]
[null,null,"Using the XPATH of: /rss/channel/item/title will select the uniquely named title node, and the JIRA Scraper will update cells using that data"]
[null,null,null,"See Row 4 of the 'Config' Worksheet"]
[null,"To select a node that does NOT have a unique XPATH (for example, any of the customfield nodes)"]
[null,null,"The non unique node can be referenced by order of fields (starting with 0) by using square brackets after the desired path"]
[null,null,null,"See Row 9 of the 'Config' Worksheet"]
[null,null,"The non unique node can also be referenced by attribute"]
[null,null,null,"See Row 10 of the 'Config' Worksheet"]
[null,"For more information on XPATH, consult the following resources:"]
[null,null,"http://www.w3schools.com/xpath/default.asp"]
[null,null,"http://en.wikipedia.org/wiki/Xpath"]